`D|D|% `D|D|% System System enterBook enterBook reader sizeToPage destination tbksort.dll sortList sortText TBKSORT.DLL Function Reference linkDLL "tbksort.dll" STRING sortList( Text( listtotextline( textlinetolist( "func#" "Function" && "desc,ret,par,ex" " && rf > 0 enterBook enterPage enterBook reader sizeToPage tbksort.dll sortList sortText listtotextline textlinetolist enterPage func# Function desc,ret,par,ex recordfield rectangle scrolling STRING sortList(STRING) This function sorts the list contained in the single string parameter. The sort is case-sensitive so that A is sorted before a. Numbers are sorted as text so that a 10 will always be sorted before a 2. The sorted list is returned. Where possible (e.g. system variables), the original copy of the list is sorted. The single parameter is the comma-separated list to be sorted. 001,200,212,3,003,9,332,abc,ABC,def,DEF,b,a,A,B,2,100,103,534,454,399,332,abc,ABC,def,DEF,b,a,A,B,2,100000 --This example sorts the list in source field. linkDLL "tbksort.dll" STRING sortList(STRING) end linkDLL put sortList(text of recordField "source") \ into text of recordField "destination"ource") \ into text of recordField "destination" 001,200,212,3,003,9,332,abc,ABC,def,DEF,b,a,A,B,2,100BILL STRING listToTextline(STRING) This function converts a comma-separated list to a CRLF-separated string. The converted string with each item separated by a CRLF is returned., the original copy of the list is converted. The single parameter is the comma-separated list to be converted. --This converts the list in the source field to its CRLF-separated --equivalent. linkDLL "tbksort.dll" STRING listToTextLine(STRING) end linkDLL put listToTextline(text of recordField "source") \ into text of recordField "destination"cordField "par"))))recordField "par")ordField "par")of recordField "par") \ text of recordField "par" Amanda,Xavier,John,Joe,Mary,Barbara,Collin source destination buttonUp buttonUp Execute Script "destination" buttonUp buttonUp destination Clear Destination buttonUp buttonUp Copy Script to Clipboard proto Prototype Description Return Value Parameters Example buttonUp buttonUp buttonUp buttonUp Source Destination func# Function 4 of 4 FindWindow STRING sortText(STRING))))))))) This function sorts the textlines of the single parameter. The sort is case-sensitive so that A is sorted before a. Numbers are sorted as text so that a 10 will always be sorted before a 2.minimized. This sorted string is returned. Where possible (e.g. system variables), the original parameter is sorted.nd. The single parameter is the string to be sorted. The textlines of the string are separated with CRLFs. CCCCCCCCCCCCCCCd the FindWindow function will look for any window with the specified caption (see next parameter). The second parameter is the caption of the window you are looking for. For example, "Must Have DLL Function Calls" is the caption of this ToolBook main window. "Program Manager" is the caption of the Program Manager window. --This example sorts the textlines of the source field. linkDLL "tbksort.dll" STRING sortText(STRING) end linkDLL put sortText(text of recordField "source") into \ text of recordField "destination"tination" nd if get ShowWindow(hWnd, 7) --Minimize ExcelWindow(hWnd, 7) --Minimize ExcelwWindow(hWnd, 7) --Minimize ExcelpUptonUppnUpnUpnUpnUpnUpnUpnUpnUp Collin Amanda Barbara FindWindow STRING textlineToList(STRING) This function converts a CRLF-separated string to a comma-separated list.alent.t.RLF-. A comma-separated list is returned. Where possible (e.g. system variables) the original copy of the list is converted.d.ed........ The single parameter is the string containing textlines to be converted. --This converts the list in the source field to its CRLF-separated --equivalent. linkDLL "tbksort.dll" STRING listToTextLine(STRING) end linkDLL put textlineToList(text of recordField "source") \ into text of recordField "destination" Amanda Xavier Barbara Collinn